home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Tech Arsenal 1
/
Tech Arsenal (Arsenal Computer).ISO
/
tek-19
/
t123v13.zip
/
TAB123.DOC
< prev
next >
Wrap
Text File
|
1992-05-07
|
23KB
|
519 lines
Tab123, copyright 1991,92 Mountain Software
-=Tab123=-
AutoCAD Spreadsheet Interface Utility
Version 1.3
May 2, 1992
_______
____|__ | (R)
--| | |-------------------
| ____|__ | Association of
| | |_| Shareware
|__| o | Professionals
-----| | |---------------------
|___|___| MEMBER
Autodesk Registered Developer
Jerry Workman, P.E.
1579 Nottingham Road
Charleston, WV 25314
CIS 70717,3564
Orders: 1-800-2424-PsL
Table of Contents
I. U s i n g T a b 1 2 3 . . . . . . . . . . . . . . . . 3
Purpose . . . . . . . . . . . . . . . . . . . . . . . . 3
Installation . . . . . . . . . . . . . . . . . . . . . . 3
Running Tab123 . . . . . . . . . . . . . . . . . . . . . 4
Read_WKS . . . . . . . . . . . . . . . . . . . . . . . . 5
Limits . . . . . . . . . . . . . . . . . . . . . . . . . 6
Suggestions . . . . . . . . . . . . . . . . . . . . . . 6
II. A d d e n d u m . . . . . . . . . . . . . . . . . . . . 6
Error Messages . . . . . . . . . . . . . . . . . . . . . 6
Liability . . . . . . . . . . . . . . . . . . . . . . . 7
Author . . . . . . . . . . . . . . . . . . . . . . . . . 7
III. L i c e n s e . . . . . . . . . . . . . . . . . . . . . 8
Registration Information . . . . . . . . . . . . . . . . 8
Definition of Shareware . . . . . . . . . . . . . . . . 9
Disclaimer - Agreement . . . . . . . . . . . . . . . . . 9
Trademark . . . . . . . . . . . . . . . . . . . . . . 10
IV. I n d e x . . . . . . . . . . . . . . . . . . . . . . 11
I. U s i n g T a b 1 2 3
============================
Purpose
-------
Tab123 is a utility that provides the ability to import Lotus 123
and Symphony spreadsheet files into an AutoCAD drawing as a table
of text entities, and if desired, a cell grid to enclose the
table. Tab123 runs from within the AutoCAD drawing editor and
will read .WKS, WK1, and WRK files directly. The program reads
not only the data from the spreadsheet file, but also calculated
formula values. Formatting information; Column widths, cell
formats, and cell alignment are also read and used to create the
table. Tab123 is executed through an AutoLisp program
(TAB123.LSP) and an external executable program (READ_WKS.EXE).
Tab123 works on any IBM PC compatible computer capable of running
AutoCAD.
Installation
------------
Copy the Tab123 files from the distribution diskette (or extract
them from the archive file) to your AutoCAD subdirectory, or to
sub-directories where DOS and AutoCAD can find them. READ_WKS.EXE
can be in any directory that is on the DOS PATH. TAB123.LSP must
be in a directory that is in the AutoCAD library path. If you are
not sure of your DOS or AutoCAD paths, place both files in the
same directory as ACAD.EXE (usually C:\ACAD). To insure that
AutoCAD can find files in your support directory, add the
following to your AUTOEXEC.BAT file:
SET ACAD=C:\ACAD\SUPPORT (or where ever your support files are
located)
NOTE: The AutoCAD command SHELL must work so that
READ_WKS.EXE can execute.
Running Tab123
-------------------
First load the AutoLISP program:
Command: (LOAD"TAB123")
Then execute...
Command: TAB123
Follow the prompts:
Load/Draw/All/Parms/Exit/<All>:
Load: Loads a spreadsheet file, an external DOS program
(READ_WKS.EXE) is executed to convert the data in a
range to a format that AutoLISP can read. A file named
ACAD.123 is created in the current directory containing
the extracted data.
Draw: Draws the previously loaded table in the drawing. You
are prompted for the table location, and text size (if
the current style has a text size of 0.0), and if you
wish a grid drawn. The file ACAD.123, created in the
previous step, is read and the table drawn.
All Both Loads and Draws the table
Parms Display / change Tab123 variables
RowScaleFactor/CharOffsetFactor/Exit/<Exit>:
RowScaleFactor: Centers / spacing between rows. A value of
2.0 (the default) will space rows at 2.0 x text height
(determined by the AutoCAD text style active or the height
entered by the user).
CharOffsetFactor: Offset of the first and last character(s)
from the left and right margins. A value of 1.0 (the
default) will make cell margins 1.0 X text character width
(determined by the AutoCAD text style active).
Exit: Exits Tab123 with no action.
Read_WKS will then execute prompting...
Enter worksheet filename:
Enter any valid DOS filename including
Drive:\path\filename.ext. If no file extension is specified
then ".WK1" is appended.
Enter worksheet range, range name, "*" for all cells
or ? to list defined ranges[default A1..D25]:
Enter either a worksheet range in the usual form (eg
BA34..CL63) or any range name defined in the worksheet. You
may enter a question mark "?" to list all range names in the
selected worksheet file. Enter an asterisk "*" to specify
the entire worksheet.
Table Insertion point:
Pick a point where for the upper left corner of the table.
Text Height <0.2>:
Enter the text height for all entities in the table. The
default height for the current test style is used if no
value is entered.
Create table grid?<Yes>:
Enter "Y" to draw a grid of LINE entities around all cells.
Read_WKS
--------
Read_WKS is the DOS executable program that does the actual
extraction from the worksheet file. Read_WKS is a very powerful
program which can be used external to AutoCAD to extract data
from a .WK? files in comma delimited format, for use by other
programs, or for reporting. Read_WKS operated from the DOS
command line using switches and parameters to control it's
operations. The switches / commands / functions are as follows:
Usage: READ_WKS <switches> <filename>.WK1 <outfilename>
The .WK1 extension is added to <filename> if omitted.
<outfilename> can also be CON, PRN, STDOUT or any DOS device.
Switches must start with / or - and are not case sensitive.
/D Debug diagnostic display
/R___ Lotus Range [default A1..D25] (eg /RB11..F35)
or "*" for the entire worksheet (/R*)
/A AutoCAD LISP output (default output filename is
ACAD.123)
/E AppEnd output to the output file
/I Ignore repeating label cells (eg \=)
/U Unformatted (maximum precision) output
/X eXpanded formatted report output, no delimiter, fully
formatted
/S_ Separator / Delimiter character(s) (eg /S;)
/Q Quiet, no display except errors
/P Password program - register Read_WKS
/H Help - This message.
Example: READ_WKS /RC19..F35 MYFILE MYFILE.PRN
Or: READ_WKS /A /R* MYFILE
Limits
------
Tab123 can not read version 2.3, 3.X Lotus, 123G or SQZ files. If
you use a version of Lotus 123 after version 2.2 or a different
spreadsheet program (eg Quattro or Excel) then save your file as
a .WK1 or .WKS file, most spreadsheets (and many other programs)
provide can save in these file formats.
Tab123 / Read_WKS can not recalculate your spreadsheet. If you
use manual recalculation then be sure to recalculate prior to
saving so that formula values will be correctly displayed.
If you wish to extract tables from very large spreadsheets then
you must provide the DOS program READ_WKS.EXE with as much memory
as possible. With AutoCAD 386 the programs BigShell and SHROOM
will provide a large memory SHELL. SHROOM.COM is included with
AutoCAD release 11 and a shareware version is available on
Compuserve and many Computer Bulletin boards.
Suggestions
-----------
* While developing your table in Lotus 123 (or your favorite
spreadsheet) make sure that text does not overlap into the
next cell. Set column widths to a value that is just wider
than the values and text. Use "Comma" or "Dollars" formats
to make large values easier to read.
* You can use Tab123 to transfer attribute information from
Generic CADD to AutoCAD. In CADD 5.0, export attribute data
as a WK1-format file; then use Tab123 to read the file into
AutoCAD as a text table.
II. A d d e n d u m
====================
Error Messages
--------------
Unidentified file format
The file signature does not match a known file type.
Cannot open file XXXX
Reason: Misspelled filename or possible disk error.
Unknown switch => X <=
An unknown DOS command line switch was passed to
READ_WKS.EXE.
Out of memory
READ_WKS requires about 100K to run. Revise your SHELL entry
in your ACAD.PGP file or use SHROOM to increase SHELL
memory.
Unidentified Cell. OpCode = XXh Length = XX
Usually caused by processing a spreadsheet file format not
known by READ_WKS.EXE.
Unexpected end of input file
The end of the file was reached before the end of file
record was read.
Error reading input file
Error writing to output file
A disk error during a read or write operation occurred.
Liability
---------
Careful testing has been made to ensure that these programs
perform correctly. No liabilities are assumed in the use or
misuse of this program resulting in data loss or damage. It is
the users responsibility to be sure that the results are as
expected.
Author
------
If you have any suggestions or comments, please contact me.
Jerry Workman, PE
1579 Nottingham Rd.
Charleston, WV 25314
CIS 70717,3564
304-744-7748 (after 7:30PM ET)
Copyright 1991,92 by Mountain Software All rights reserved
III. L i c e n s e
==================
Shareware
---------
This version of Tab123 is NOT public domain or free software, but
is being distributed as "shareware". You may try it out to see if
it is useful for you. If you wish to continue to use Tab123 you
must register. Registered users are provided with a password to
remove the opening delay and with support for one year.
The program in the form of the original archived file only may be
freely distributed, but not sold (except under license, or for a
nominal copying or disk fee).
Non-registered users of this software are granted a limited 30
day license to make an evaluation copy for trial use for the
purpose of determining whether Tab123 is suitable for their
needs. At the end of this trial period, you may either register
your copy, or discontinue using Tab123.
All users are granted a limited license to copy Tab123 only for
the trial use of others and subject to the above limitations.
This license does NOT include distribution or copying of this
software for use:
1. In connection with any other product or service.
2. For general use within a company or institution.
3. For distribution in modified form; i.e., the file containing
this license information MUST be included, along with the
full Tab123 documentation.
Operators of electronic bulletin board systems (Sysops) are
encouraged to post TAB123xx.ZIP for downloading by their users,
as long as these conditions are met.
Registration Information
------------------------
A Tab123 registration licenses you to use the product on a
regular basis. Individual license cost for Tab123 is $30
including a diskette with the latest version of Tab123 for an
additional and the printed manual. West Virginia residents should
include 6% sales tax. The file ORDER.DOC is an order form.
Educational institutions, full-time students and BBS sysops can
apply a 50% discount. PLEASE include your educational institution
letterhead (with your title), or a photocopy of your most recent
registration slip, or the name and number of your BBS.
Definition of Shareware
-----------------------
Shareware distribution gives users a chance to try software
before buying it. If you try a Shareware program and continue
using it, you are expected to register. Individual programs
differ on details -- some request registration while others
require it, some specify a maximum trial period. With
registration, you get anything from the simple right to continue
using the software to an updated program with printed manual.
Copyright laws apply to both Shareware and commercial software,
and the copyright holder retains all rights, with a few specific
exceptions as stated below. Shareware authors are accomplished
programmers, just like commercial authors, and the programs are
of comparable quality. (In both cases, there are good programs
and bad ones!) The main difference is in the method of
distribution. The author specifically grants the right to copy
and distribute the software, either to all and sundry or to a
specific group. For example, some authors require written
permission before a commercial disk vendor may copy their
Shareware.
Shareware is a distribution method, not a type of software. You
should find software that suits your needs and pocketbook,
whether it's commercial or Shareware. The Shareware system makes
fitting your needs easier, because you can try before you buy.
And because the overhead is low, prices are low also. Shareware
has the ultimate money-back guarantee -- if you don't use the
product, you don't pay for it.
Disclaimer - Agreement
----------------------
Users of Tab123 must accept this disclaimer of warranty: "Tab123
is supplied as is. The author disclaims all warranties,
expressed or implied, including, without limitation, the
warranties of merchantability and of fitness for any purpose. The
author assumes no liability for damages, direct or consequential,
which may result from the use of Tab123."
Tab123 is a "shareware program" and is provided at no charge to
the user for evaluation. Feel free to share it with your
friends, but please do not give it away altered or as part of
another system. The essence of "user-supported" software is to
provide personal computer users with quality software without
high prices, and yet to provide incentive for programmers to
continue to develop new products. If you find this program
useful and find that you are using Tab123 and continue to use
Tab123 after a reasonable trial period, you must make a
registration payment of $30 to Mountain Software. The $30
registration fee will license one copy for use on any one
computer at any one time. You must treat this software just like
a book. An example is that this software may be used by any
number of people and may be freely moved from one computer
location to another, so long as there is no possibility of it
being used at one location while it's being used at another. Just
as a book cannot be read by two different persons at the same
time.
Commercial users of Tab123 must register and pay for their copies
of Tab123 within 30 days of first use or their license is
withdrawn. Site-License arrangements may be made by contacting
Mountain Software.
Anyone distributing Tab123 for any kind of remuneration must
first contact Mountain Software at the address below for
authorization. This authorization will be automatically granted
to distributors recognized by the (ASP) as adhering to its
guidelines for shareware distributors, and such distributors may
begin offering Tab123 immediately (However Mountain Software must
still be advised so that the distributor can be kept up-to-date
with the latest version of Tab123.).
You are encouraged to pass a copy of Tab123 along to your friends
for evaluation. Please encourage them to register their copy if
they find that they can use it.
Jerry Workman a member of the Association of Shareware
Professionals (ASP). ASP wants to make sure that the shareware
principle works for you. If you are unable to resolve a
shareware-related problem with an ASP member by contacting the
member directly, ASP may be able to help. The ASP Ombudsman can
help you resolve a dispute or problem with an ASP member, but
does not provide technical support for members' products. Please
write to the ASP Ombudsman at 545 Grover Road, Muskegon MI 49442,
or send a message via Compuserve mail to ASP Ombudsman 70007,3536
Trademark
---------
Mountain Software, Read_WKS, and Tab123 are trademarks of
Mountain Software. MS-DOS is a registered trademark of Microsoft
Corporation. PC-DOS is a registered trademark of IBM Corporation.
AutoCAD is a registered trademark of AutoDesk. 123 and Symphony
are registered trademarks of Lotus Development Corporation
IV. I n d e x
123 . . . . . . . . . . . . . . . . . . . . . . 3-6, 10
ACAD . . . . . . . . . . . . . . . . . . . . . 3-5, 7
ACAD.EXE . . . . . . . . . . . . . . . . . . . . . . 3
ASP . . . . . . . . . . . . . . . . . . . . . . . . 10
AutoCAD . . . . . . . . . . . . . . . . . . 1, 3-6, 10
bulletin boards . . . . . . . . . . . . . . . . . . . 6
Command . . . . . . . . . . . . . . . . . . . . . . 3-6
Compuserve . . . . . . . . . . . . . . . . . . . 6, 10
directory . . . . . . . . . . . . . . . . . . . . 3, 4
disk . . . . . . . . . . . . . . . . . . . . . . . 6-9
DOS . . . . . . . . . . . . . . . . . . . . . . 3-6, 10
drawing editor . . . . . . . . . . . . . . . . . . . 3
error . . . . . . . . . . . . . . . . . . . . . . 6, 7
file . . . . . . . . . . . . . . . . . . . . . . . 3-8
filename . . . . . . . . . . . . . . . . . . . . . 4-6
grid . . . . . . . . . . . . . . . . . . . . . . . 3-5
license . . . . . . . . . . . . . . . . . . . . . 8-10
LISP . . . . . . . . . . . . . . . . . . . . . . . . 5
Lotus . . . . . . . . . . . . . . . . . . . 3, 5, 6, 10
range . . . . . . . . . . . . . . . . . . . . . . 4, 5
range name . . . . . . . . . . . . . . . . . . . . . 5
shareware . . . . . . . . . . . . . . . . . 1, 6, 8-10
SHELL . . . . . . . . . . . . . . . . . . . . . 3, 6, 7
SHROOM . . . . . . . . . . . . . . . . . . . . . 6, 7
subdirectory . . . . . . . . . . . . . . . . . . . . 3
table . . . . . . . . . . . . . . . . . . . . . . . 2-6
worksheet . . . . . . . . . . . . . . . . . . . . 4, 5
ZIP . . . . . . . . . . . . . . . . . . . . . . . . . 8